Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

PROC–STATUS function

Returns the return status from an ODBC stored procedure. The return status is an integer value that indicates whether a stored procedure failed and why it failed. See your ODBC data-source documentation for descriptions of the possible values for the return status:

Syntax

PROC-STATUS

Example

This procedure runs the stored procedure pcust and writes the results of the stored procedure into the Progress 4GL buffer, proc–text–buffer. The CLOSE STORED–PROCEDURE statement then retrieves the output parameters. The return status is written to the variable stat and is displayed:

DEFINE VAR stat AS INTEGER. RUN STORED-PROCEDURE pcust (10, OUTPUT 0, OUTPUT 0). FOR EACH proc-text-buffer: DISPLAY proc-text-buffer. END. CLOSE STORED-PROCEDURE pcust stat = PROC-STATUS. DISPLAY stat.

Note

For descriptions of the possible values for the return status of a non-Progress 4GL stored procedure, see your data-source documentation.

See also

CLOSE STORED–PROCEDURE statement, PROC–HANDLE function, RUN STORED–PROCEDURE statement